package com.yenlien.traceyun.plant.dao;

import com.yenlien.traceyun.plant.entity.YenlienProduct;
import com.yenlien.traceyun.webase.dao.BaseJpaDao;
import org.springframework.data.jpa.repository.Query;

import java.util.List;


public interface YenlienProductDao extends BaseJpaDao<YenlienProduct> {


    @Query(value = "SELECT `name` FROM t_yenlien_product WHERE state = '1' GROUP BY `name`", nativeQuery = true)
    List<String> findProdType();




}
